7.6 KB · ⇊ 5 parts · ⤓ Micron 7.6 KB · ⤓ HTML 29.4 KB

top

Toad is a database management toolset from Quest Software for managing relational and non-relational databases using SQL aimed at database developers, database administrators, and data analysts. The Toad toolset runs against Oracle, SQL Server, IBM DB2 (LUW & z/OS), SAP and MySQL. A Toad product for data preparation supports many data platforms.

• History

• Features

• Books

• See also

• References

• External links

A practicing Oracle DBA, Jim McDaniel, designed Toad for his own use in the mid-1990s.cite-ref-1[1] He called it Tool for Oracle Application Developers, shortened to "TOAD". McDaniel initially distributed the tool as shareware and later online as freeware.

Quest Software acquired TOAD in October 1998.cite-ref-2[2] Quest Software itself was acquired by Dell in 2012 to form Dell Software.cite-ref-3[3]cite-ref-4[4] In June 2016, Dell announced the sale of their software division, including the Quest business, to Francisco Partners and Elliott Management Corporation.cite-ref-5[5] On October 31, 2016, the sale was finalized. On November 1, 2016, the sale of Dell Software to Francisco Partners and Elliott Management was completed, and the company re-launched as Quest Software.cite-ref-6[6]

• Connection Manager - Allow users to connect natively to the vendor’s database whether on-premise or DBaaS.

• Browser - Allow users to browse all the different database/schema objects and their properties effective management.

• Editor - A way to create and maintain scripts and database code with debugging and integration with source control.

• Unit Testing (Oracle) - Ensures code is functionally tested before it is released into production.

• Static code review (Oracle) - Ensures code meets required quality level using a rules-based system.

• SQL Optimization - Provides developers with a way to tune and optimize SQL statements and database code without relying on a DBA. Advanced optimization enables DBAs to tune SQL effectively in production.

• Scalability testing and database workload replay - Ensures that database code and SQL will scale properly before it gets released into production.

• Toad Pocket Reference for Oracle plsql 1st Edition by Jim McDaniel and Patrick McGrath, O'Reilly, 2002 (ISBN 0596003374, ISBN 978-0-596-00337-1)

• Toad Pocket Reference for Oracle 2nd Edition by Jeff Smith, Bert Scalzo, and Patrick McGrath, O'Reilly, 2005 (ISBN 0596009712, ISBN 978-0-596-00971-7)

• TOAD Handbook by Bert Scalzo and Dan Hotka, Sams, 2003 (ISBN 0672324865, ISBN 978-0-672-32486-4)

• TOAD Handbook 2nd Edition by Bert Scalzo and Dan Hotka, Addison-Wesley Professional, 2009 (ISBN 0321649109, ISBN 978-0-321-64910-2).

• TOAD Handbook 2nd Edition by Bert Scalzo and Dan Hotka, Addison-Wesley Professional, 2009 (ISBN 0321649109, ISBN 978-0-321-64910-2).

• Comparison of database tools

cite-note-11. ↑ citerefscalzohotka2003Scalzo, Bert; Hotka, Dan (February 2003). Toad Handbook. Developer's Library. Jim McDaniel. Sams Publishing. p. xiv. ISBN 978-0-672-32486-4. Retrieved 2013-10-23. I've been working on TOAD now for more than six years. Or has it been seven?

cite-note-22. ↑ "Quest Software's Acquisitions". Dell Inc. Archived from the original on 2012-02-03. Retrieved 2013-03-05.

cite-note-33. ↑ "Dell to Acquire Quest Software". www.businesswire.com (Press release). 2 July 2012. Retrieved 2017-11-30.

cite-note-44. ↑ "Quest Software, its Toad tool leaping over to Dell". SearchOracle. Retrieved 2017-12-06.

cite-note-55. ↑ citerefmillerMiller, Ron. "Confirmed: Dell sells software division to Francisco Partners and Elliott Management". TechCrunch. Retrieved 2017-11-30.

cite-note-66. ↑ "Quest Launches as an Independent Software Company Backed by Francisco Partners and Elliott Management". www.businesswire.com (Press release). November 2016. Retrieved 2017-11-30.

• Official Toad User Community

• Quest Software Toad company website